Prerequisites for adding Oracle Database Server

Motadata supports monitoring of Oracle database servers of versions 10g, 10.1.3, 11g, RAC (Real Application Clusters) and 12c.

User Roles & Permissions: If you are running an Oracle 10g database or higher, follow the instructions in this section to set permissions for the user account.

Object Permissions: At a minimum, the account for database monitoring must have SELECT permissions for the following objects:

• sys.dba_tables

• sys.dba_tab_columns

• sys.dba_constraints

• sys.dba_views

• sys.dba_objects

• sys.dba_procedures

Methods to Grant Access:-

Typically, a new account does not have any SELECT permissions for the above objects. The DBA must assign the SELECT_CATALOG_ROLE role to this account. The SELECT_CATALOG_ROLE will make available the above objects as well as others. You then have the option to manually set each object’s permission level for your user. Keep in mind that if the user wishes to perform SQL queries as part of the Configuration Change Console monitoring, the tables listed above will need to be accessible to the user internally configured in your database Configuration Change Console.

After assigning SELECT_CATALOG_ROLE to this account, the agent can use the account to connect to the Oracle 9i or 10g server.